CREATE TABLE  "UPMS_ISSUE" 
   (	"ISSUEID" NUMBER NOT NULL ENABLE, 
	"CREATEDBY" CHAR(50), 
	"CATEGORYID" NUMBER, 
	"CREATEDDATE" DATE, 
	"ASSIGNEE" CHAR(50), 
	"ISSUESTATUS" CHAR(10), 
	"ISSUETYPE" VARCHAR2(500), 
	"PAGEID" CHAR(10) NOT NULL ENABLE, 
	"PRIORITY" CHAR(10), 
	"ISSUETITLE" VARCHAR2(500) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(200), 
	"COMMENTS" NVARCHAR2(2000), 
	"RESOLUTIONTYPE" CHAR(20), 
	"RESOLVEDBY" CHAR(50), 
	"RESOLVEDATE" DATE, 
	"RESOLUTION" NVARCHAR2(2000), 
	 CONSTRAINT "UPMS_ISSUE_PK" PRIMARY KEY ("ISSUEID") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "BI_UPMS_ISSUE" 
  before insert on "UPMS_ISSUE"               
  for each row  
begin   
    select "UPMS_ISSUE_SEQ".nextval into :NEW.ISSUEID from dual; 
end; 

/
ALTER TRIGGER  "BI_UPMS_ISSUE" ENABLE
/


CREATE TABLE  "UPMS_PAGE" 
   (	"SEQID" NUMBER NOT NULL ENABLE, 
	"PAGEID" CHAR(10) NOT NULL ENABLE, 
	"PAGENAME" VARCHAR2(200), 
	"PRIORITY" NUMBER, 
	"ASSIGNEE" CHAR(50), 
	"TEAM" CHAR(50), 
	"STATUS" CHAR(20), 
	"ISSUES" CHAR(100), 
	"REVIEWER" CHAR(50), 
	"COMPLETION" NUMBER, 
	"NOTES" VARCHAR2(2000), 
	"WALKTHROUGHASSIGNEE" VARCHAR2(100), 
	"EXPECTEDCOMPLETIONDATE" DATE, 
	"TESTPLANAPPROVEDFLAG" CHAR(1), 
	"UNITTESTPLANURL" VARCHAR2(200), 
	"WALKTHROUGHCHECKLISTURL" VARCHAR2(200), 
	"UNITTESTARTIFACTSURL" VARCHAR2(200), 
	 CONSTRAINT "UPMS_PAGE_PK" PRIMARY KEY ("SEQID") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "BI_UPMS_PAGE" 
  before insert on "UPMS_PAGE"               
  for each row  
begin   
    select "UPMS_PAGE_SEQ".nextval into :NEW.SEQID from dual; 
end; 

/
ALTER TRIGGER  "BI_UPMS_PAGE" ENABLE
/


        
